
/****** Object:  StoredProcedure [dbo].[web_update_password]    Script Date: 10/19/2013 09:22:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

--IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'web_update_password')
DROP PROCEDURE web_update_password
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[web_update_password] 
	@n60_pareigos varchar(100),
	@n60_kodas_sm varchar(100),
	@get_password varchar(100)
AS
BEGIN

	SET NOCOUNT ON

	UPDATE n60_asm 
	set n60_pareigos=@n60_pareigos
	where n60_kodas_sm=@n60_kodas_sm 
	and n60_pareigos=@get_password 
	and n60_poz_date=0
	
END

GO

